Creating Visual Cards: Deaths Per Mth, %MoM, %YoY and Refreshed Date 14

Adding Visual card for: Deaths Per Mth, %MoM, %YoY and Refreshed Date

Steps1

Adding Visual card for Deaths Per Mth


·         Open Visualization Pane

·         Select Visual Card

·         Drag the visual to the dashboard.

·         Click on "Death Per Mth" From All Measure and drag it into the fields.

·         General: X - Position = 21, Y - Position = 219, Width = 200, Height = 115

·         Data Label: Color = #00000,  Value Decimal = 0, Font Size = 27,  Font type = DIN

·         Category = OFF

·         Title = ON,  Text Title = " Deaths Per Mth ", Font Color = #000000 , Background Color = #cccccc ,   Font Size = 17 and Font Family = Segoe UI Bold, Alignment = Center

·         Background ON, Color = #ffffff, Transparency = 0 


Stepes2

Adding Visual card for %MoM

·         Open Visualization Pane

·         Select Visual Card

·         Drag the visual to the dashboard.

·         Click on %MoM from All Measure and drag it into the fields.

·         General: X - Position = 21, Y - Position = 352, Width = 200, Height = 115

·         Data Label: Color = #33DBFF, Font Size = 25, Font type = DIN

·         Category = OFF

·         Title = ON, Text Title = " %MoM ", Font Color = #FFFFF, Background Color = #00000, Font Size = 17 and Font Family = DIN, Alignment = Center

·         Background ON, Color = #FFFFF, Transparency = 0

 

Stepes3

Adding Visual card for %YOY

·         Open Visualization Pane

·         Select Visual Card

·         Drag the visual to the dashboard.

·         Click on %YoY from All Measure and drag it into the fields.

·         General: X - Position = 21, Y - Position = 480, Width = 200, Height = 115

·         Data Label: Color = #E1A204, Font Size = 25, Font type = DIN

·         Category = OFF

·         Title = ON, Text Title = " %YoY ", Font Color = #FFFFF, Background Color = #00000, Font Size = 17 and Font Family = DIN, Alignment = Center

·         Background ON, Color = #FFFFF, Transparency = 0

 

Steps4

Step4a: create Refresh Date

How to create Refresh Date:

  1.            Transform data to Power Query.

2.       2.     Click New sources on left corner

3.       3.     Click Blank Query

4.      4.       Enter =DateTime.LocalNow() & press enter

5.       5.      Rename Queryn1 by Date Refresh

6.       6.      Convert to Table Format

7.       7.       Rename Column1 by DateTime

8.       8.        Go to Transform and Date choose Date only

9.       9.         Duplicate DateTime and rename it Time and under Time choose Time only



Step4b: Adding Refreshed Date

·         Open Visualization Pane

·         Select Visual Card

·         Drag the visual to the dashboard.

·         Click on refreshed date from Data Refresh Table and place it inside the fields.

·         General: X - Position = 21, Y - Position =604, Width = 200, Height = 100

·         Data Label: Color = #00000, Font Size = 15, Font type = DIN

·         Category = OFF

·          Title ON, Text Title = " Refreshed Date", Font Color = #FFFFF, Background Color = #00000 ,    Font Size = 17 and Font Family = DIN

 

How to Create a Card in Power BI

https://www.tutorialgateway.org/create-a-card-in-power-bi/

How do you get a REFRESH DATE in your Power BI report??? (how to create REFRESH DATE TABLE)

https://www.youtube.com/watch?v=oN6mOmEruOQ